All Questions
12 questions
2votes
2answers
566views
Reading a large CSV file and then loading data to a DB
I have a Django application of 2 GB running and I need to receive a CSV file of more than 1 GB, read it and load the data to a PostgreSQL DB in IBM Cloud. The problem is that if I receive the file, it ...
3votes
2answers
1kviews
How should I structure my database entities with invites and recipients for e-signing web app?
I am interested in implementing the following requirements for my e-signature web application. A user can create a new signing contract. That contract can include multiple users to sign. The contract ...
0votes
1answer
1kviews
Data filtering & requests: fetch all entries or split data?
I am in a situation I cannot decide which approach is the most optimal (performance wise) while being maintainable at the same time (in the sense of having a clear logic). The question is laid in the ...
- 2,266
3votes
1answer
981views
Django: caching properties for non-changing entries
I am wondering if it is a good idea to do the following: I have a Django model (which is related to a migration, therefore it has a database entry) with a bunch of properties. Accessing these are ...
- 2,266
3votes
1answer
373views
Django Migrations: Binds data to code?
If you have custom code for models (custom validators and custom fields are examples), Django Migrations will import them directly into the migration files. An example: file web/models.py def ...
- 445
3votes
3answers
291views
Should custom data elements be stored as XML or database entries?
There are a ton of questions like this, but they are mostly very generalized, so I'd like to get some views on my specific usage. General: I'm building a new project on my own in Django. It's focus ...
- 171
65votes
5answers
38kviews
Is backing up a MySQL database in Git a good idea?
I am trying to improve the backup situation for my application. I have a Django application and MySQL database. I read an article suggesting backing up the database in Git. On the one hand I like it,...
- 1,891
1vote
1answer
871views
Best practices when dealing with lots of empty table columns?
I have a schema that allows for multiple post types in my Django project (kinda like Tumblr). Users can make Posts of different types. One of those types is a photo, which I'll want the EXIF data for. ...
- 255
2votes
2answers
1kviews
Should model / table names be as generic as possible?
When naming a model, should the name be as generic as possible-- even if that won't be the name displayed to users? For example let's imagine a Django model for liking another user's posts. Does it ...
- 255
3votes
4answers
1kviews
Notify players every x seconds in a multiplayer game
I'm working on a realtime multiplayer game using Django and gevent-socketio, I'm facing some issues: I need to send an update of the game state to connected players every X seconds (~4 seconds), so ...
- 165
5votes
3answers
2kviews
Should we have a database independent SQL like query language in Django?
Note : I know we have Django ORM already that keeps things database independent and converts to the database specific SQL queries. Once things starts getting complicated it is preferred to write raw ...
- 359
0votes
1answer
322views
Keeping "historical" migrations in Django-south
After a system has gone through many migrations, and evolved enough for a second version, does it make sense to keep the old migrations around? I mean, old versions will use them to upgrade to the new ...
- 504
